4. OPEN JOB DETAILS

Download the above zip file ( JOB_REFERRAL_STEP 4.zip)  Using the provided template (OPENJOBDETAILSTEMPLATE_STEP 4.pbix), follow through to recreate the highlighted visuals below




1a. CREATE CALCULATED COLUMN

DAX Code Used:  JobOpenDateDiff= DATEDIFF(JobReferral_VW[JobRefStartDate].[Date],JobReferral_VW[JobRefEndDate].[Date],DAY)



1b. CREATE CALCULATED MEASURE

DAX Code Used: AverageOpenJobReferrals = AVERAGE(JobReferral_VW[JobOpenDateDiff2])



1. AVERAGE OPEN JOB REFERRALS



2. DETAILS OF OPEN JOBS

 

3. COUNT OF HIRING COMPANIES JOBTAGS 



Feel Free to Download the completed Dashboard (OPENJOBDETAILSCOMPLETED_STEP 4.pbix)  from the already downloaded file (JOB_REFERRAL_STEP 4.zip) 

 

Read more about the differences between Calculated columns and Calculated Measures: https://www.sqlbi.com/articles/calculated-columns-and-measures-in-dax/